A New Parallel MOLAP Data Cube Construction Scheme
نویسندگان
چکیده
6 X MOLAP X &' ()* '+ X bcd Ne Z X mno klp t A New Parallel MOLAP Data Cube Construction Scheme Dong JIN, Tatsuo TSUJI, and Ken HIGUCHI † Graduate School of Engineering, University of Fukui Bunkyo 3–9–1, Fukui-shi, Fukui, 910–8507 Japan E-mail: †{jindong,tsuji}@pear.fuis.fukui-u.ac.jp, ††[email protected] Abstract The pre-computation of data cubes is critical for improving the response time of multidimensional OLAP systems. In order to meet the need for improved performance created by growing data sizes, parallel solutions for data cube construction are becoming increasingly important. This paper presents two parallel methods for data cube construction based on an extendible multidimensional array, which is dynamically extendible along any dimension without relocating any existing data. Load balancing is achieved by simple solutions on shared-memory multiprocessors. Quantitative analysis on the performance limit and parallel scalability of the methods are also given in this paper.
منابع مشابه
Incremental Aggregation on MOLAP Cube Based on n-Dimensional Extendible Karnaugh Arrays
Data is increasing so rapidly that new data warehousing approaches are required to process and analyze data. Aggregation of data incrementally is needed to fast access of data and compute aggregation functions. Multidimensional arrays are generally used for this purpose. But some disadvantages such as address space requirement is large and processing time is comparatively slow in case of aggreg...
متن کاملParallel data cube construction for high performance on-line analytical processing
Decision support systems use On-Line Analytical Processing (OLAP) to analyze data by posing complex queries that require diierent views of data. Traditionally , a relational approach (ROLAP) has been taken to build such systems. More recently, multi-dimensional database techniques (MOLAP) have been applied to decision-support applications. Data is stored in multi-dimensional arrays which is a n...
متن کاملA Parallel and Distributed Method for Computing High Dimensional MOLAP
Data cube has been playing an essential role in fast OLAP(on-line analytical processing) in many multidimensional data warehouse. We often execute range queries on aggregate cube computed by pre-aggregate technique in MOLAP. For the cube with d dimensions, it can generate 2 cuboids. But in a high-dimensional data warehouse (such as the applications of bioinformatics and statistical analysis, et...
متن کاملRolap and molap pdf
Data Warehousing and OLAP: MOLAP and ROLAP dr. Toon Calders t.calderstue.nl. Data cubes as a.dimensional OLAP MOLAP approach, but also a relational OLAP ROLAP solution. Relational OLAP ROLAP using SAS OLAP Server and Teradata.Describes the advantages and the disadvantages of the different OLAP technologies: MOALP, ROLAP, and HOLAP.ROLAP relational online analytical processing is an alternative ...
متن کاملAn Approach of Non-additive Measures Compression in Molap Enviroment
On Line Analytical Processing (OLAP) is an approach to provide the answer to analytical queries. Pre-aggregation is one of the most important techniques used to speed up the query response time. However, if many aggregates are precomputed, then the database can quickly multiply in size. In this paper we present a scheme of how to decrease the storage size of a multidimensional data cube if you ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2010